﻿using System;
using System.Drawing;
using System.Windows.Forms;
using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
using FarPoint.Win.Spread.Model;

namespace Spread.Worksheet.Features
{
    public partial class DragFillDemo : Spread.Common.Features.Sample.BaseSampleControl
    {
        private DateTimeCellType _dateCell;
        private double _date;

        #region ctor
        public DragFillDemo()
        {
            InitializeComponent();
            Name = "Drag Fill";

            _dateCell = new DateTimeCellType();
            _date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 28).ToOADate();

            InitSpreadSheet(fpSpread.ActiveSheet);
            InitControls();

            checkBoxAllowDragFill.CheckedChanged += CheckBoxAllowDragFill_CheckedChanged;
            checkBoxEnableDragFillMenu.CheckedChanged += CheckBoxEnableDragFillMenu_CheckedChanged;
            checkBoxDragFillDataOnly.CheckedChanged += CheckBoxDragFillDataOnly_CheckedChanged;
            comboDragFillMode.SelectedIndexChanged += ComboDragFillMode_SelectedIndexChanged;
            comboSampleData.SelectedIndexChanged += ComboSampleData_SelectedIndexChanged;

            btnFill.Click += BtnFill_Click;

            fpSpread.ActiveSheetChanged += FpSpread_ActiveSheetChanged;
        }
        #endregion

        #region Private methods
        private void InitSpreadSheet(SheetView sheet)
        {
            fpSpread.AllowCellOverflow = true;
            fpSpread.AllowEditOverflow = true;
            fpSpread.AllowDragFill = true;
            fpSpread.EnableDragFillMenu = true;
            fpSpread.DragFillDataOnly = false;
            sheet.SelectionPolicy = SelectionPolicy.Range;

            sheet.SheetName = "Drag Fill";
            sheet.Cells[1, 1].Text = "Select a cell with data below, hold your cursor over the " +
                "bottom right border until you see the ‘+’,";
            sheet.Cells[2, 1].Text = "Then drag down to autofill the cell data.";

            sheet.Columns[3].Width = 120;
            sheet.Cells[4, 3].Text = "Sample Data";
            sheet.SetArray(5, 3, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 } });
            sheet.Cells[5, 3, 10, 3].BackColor = Color.LightYellow;
            sheet.Cells[5, 3, 10, 3].ForeColor = Color.Green;

            SheetView customSheet = new SheetView("Custom Fill");
            fpSpread.Sheets.Add(customSheet);

            customSheet.Cells[1, 1].Text = "Custom Drag-Fill";
            customSheet.Cells[1, 1].Font = new Font("Segoe", 12, FontStyle.Bold);
            customSheet.Cells[1, 1].ForeColor = Color.CadetBlue;
            customSheet.Rows[1].Height = 20;

            customSheet.Cells[2, 1].Text = "Select a range of cells and set Drag-Fill parameters";
            customSheet.Cells[3, 1].Text = "Only Data: Copy only data (or include Styles and Spans)";
            customSheet.Cells[4, 1].Text = "Only Values: Copy only values (or include Formulas, Notes, and Tags)";
            customSheet.Cells[5, 1].Text = "Fill Series: If possible copy progression of selected range (otherwise copy selected range)";

            sheet.Rows[1, 5].Locked = true;

            AddSampleData(customSheet);
            AddCustomFillSeries();
        }

        private void InitControls()
        {
            foreach (var fillMode in Enum.GetValues(typeof(DragFillMode)))
                comboDragFillMode.Items.Add(fillMode);
            comboDragFillMode.SelectedIndex = 0;
            fpSpread.RangeDragFillMode = (DragFillMode)comboDragFillMode.SelectedItem;

            comboSampleData.SelectedIndex = 0;

            foreach (var direction in Enum.GetValues(typeof(FillDirection)))
                comboFillDirection.Items.Add(direction);
            comboFillDirection.SelectedItem = FillDirection.Down;
        }

        private void AddCustomFillSeries()
        {
            fpSpread.CustomFillSeriesList.AddList(new string[] { "Mercury", "Venus", "Earth", "Mars", "Jupiter",
                "Saturn", "Uranus", "Neptune" });
        }

        private void AddSampleData(SheetView sheet)
        {
            for (int i = 0; i < 5; ++i)
                sheet.Cells[12 + i, 2].Value = i + 1;

            System.Globalization.DateTimeFormatInfo dateFormatInfo = new System.Globalization.DateTimeFormatInfo();
            var monthNames = dateFormatInfo.AbbreviatedMonthNames;
            for (int i = 0; i < 6; ++i)
                sheet.Cells[12 + i, 8].Value = monthNames[i];

            sheet.SetClip(20, 5, 3, 1, String.Join("\n", "Mercury", "Venus", "Earth"));
        }
        #endregion

        #region Event handlers
        private void FpSpread_ActiveSheetChanged(object sender, EventArgs e)
        {
            groupBox4.Enabled = fpSpread.ActiveSheetIndex == 1;
            groupBox3.Enabled = !(fpSpread.ActiveSheetIndex == 1);
        }

        private void BtnFill_Click(object sender, EventArgs e)
        {
            CellRange range = fpSpread.ActiveSheet.GetSelection(0);
            if (range == null)
            {
                MessageBox.Show("Please select a valid range", "Range Selection", MessageBoxButtons.OK,
                    MessageBoxIcon.Information);
                return;
            }

            try
            {
                int fillCount = int.Parse(txtFillCount.Text);
                fpSpread.ActiveSheet.FillRange(range.Row, range.Column, range.RowCount, range.ColumnCount,
                fillCount, (FillDirection)comboFillDirection.SelectedItem, checkBoxOnlyData.Checked,
                checkBoxOnlyValues.Checked, checkBoxFillSeries.Checked, fpSpread.CustomFillSeriesList);
            }
            catch (ArgumentOutOfRangeException)
            {
                MessageBox.Show("Invalid FillCount value", "Invalid Input", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (FormatException)
            {
                MessageBox.Show("Cannot parse FillCount value. A whole number is expected.", "Invalid Format", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void ComboSampleData_SelectedIndexChanged(object sender, EventArgs e)
        {
            int row = 5, col = 3;
            fpSpread.ActiveSheet.Cells[row, col, row + 5, col].ResetCellType();
            switch (comboSampleData.SelectedIndex)
            {
                case 0:
                    for (int i = 0; i < 6; ++i)
                        fpSpread.ActiveSheet.Cells[row + i, col].Value = i + 1;
                    break;
                case 1:
                    for (int i = 0; i < 6; ++i)
                        fpSpread.ActiveSheet.Cells[row + i, col].Value = (i + 1).ToString();
                    break;
                case 2:
                    for (int i = 0; i < 6; ++i)
                        fpSpread.ActiveSheet.Cells[row + i, col].Value = "Drag-fill data";
                    break;
                case 3:
                    for (int i = 0; i < 6; ++i)
                        fpSpread.ActiveSheet.Cells[row + i, col].Value = _date++;
                    fpSpread.ActiveSheet.Cells[row, col, row + 5, col].CellType = _dateCell;
                    break;
                case 4:
                    for (int i = 0; i < 3; ++i)
                    {
                        fpSpread.ActiveSheet.Cells[row + 2 * i, col].Value = $"Date {i + 1}";
                        fpSpread.ActiveSheet.Cells[row + 2 * i + 1, col].Value = _date++;
                        fpSpread.ActiveSheet.Cells[row + 2 * i + 1, col].CellType = _dateCell;
                    }
                    break;
            }
        }

        private void ComboDragFillMode_SelectedIndexChanged(object sender, EventArgs e)
        {
            fpSpread.RangeDragFillMode = (DragFillMode)comboDragFillMode.SelectedItem;
        }

        private void CheckBoxDragFillDataOnly_CheckedChanged(object sender, EventArgs e)
        {
            fpSpread.DragFillDataOnly = checkBoxDragFillDataOnly.Checked;
        }

        private void CheckBoxEnableDragFillMenu_CheckedChanged(object sender, EventArgs e)
        {
            fpSpread.EnableDragFillMenu = checkBoxEnableDragFillMenu.Checked;
        }

        private void CheckBoxAllowDragFill_CheckedChanged(object sender, EventArgs e)
        {
            fpSpread.AllowDragFill = checkBoxAllowDragFill.Checked;
        }
        #endregion
    }
}


//
//DragFillDemo.Designer.cs
//


namespace Spread.Worksheet.Features
{
    partial class DragFillDemo
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.fpSpread = new FarPoint.Win.Spread.FpSpread();
            this.fpSpread_Sheet1 = new FarPoint.Win.Spread.SheetView();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.checkBoxDragFillDataOnly = new System.Windows.Forms.CheckBox();
            this.checkBoxEnableDragFillMenu = new System.Windows.Forms.CheckBox();
            this.checkBoxAllowDragFill = new System.Windows.Forms.CheckBox();
            this.groupBox2 = new System.Windows.Forms.GroupBox();
            this.comboDragFillMode = new System.Windows.Forms.ComboBox();
            this.groupBox3 = new System.Windows.Forms.GroupBox();
            this.comboSampleData = new System.Windows.Forms.ComboBox();
            this.groupBox4 = new System.Windows.Forms.GroupBox();
            this.txtFillCount = new System.Windows.Forms.TextBox();
            this.checkBoxFillSeries = new System.Windows.Forms.CheckBox();
            this.checkBoxOnlyValues = new System.Windows.Forms.CheckBox();
            this.checkBoxOnlyData = new System.Windows.Forms.CheckBox();
            this.comboFillDirection = new System.Windows.Forms.ComboBox();
            this.label6 = new System.Windows.Forms.Label();
            this.label2 = new System.Windows.Forms.Label();
            this.btnFill = new System.Windows.Forms.Button();
            this.pnlMain.SuspendLayout();
            this.pnlControls.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread_Sheet1)).BeginInit();
            this.groupBox1.SuspendLayout();
            this.groupBox2.SuspendLayout();
            this.groupBox3.SuspendLayout();
            this.groupBox4.SuspendLayout();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this.fpSpread);
            this.pnlMain.Size = new System.Drawing.Size(477, 618);
            // 
            // pnlControls
            // 
            this.pnlControls.Controls.Add(this.groupBox4);
            this.pnlControls.Controls.Add(this.groupBox3);
            this.pnlControls.Controls.Add(this.groupBox2);
            this.pnlControls.Controls.Add(this.groupBox1);
            this.pnlControls.Size = new System.Drawing.Size(157, 618);
            // 
            // fpSpread
            // 
            this.fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this.fpSpread.Location = new System.Drawing.Point(0, 0);
            this.fpSpread.Name = "fpSpread";
            this.fpSpread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this.fpSpread_Sheet1});
            this.fpSpread.Size = new System.Drawing.Size(477, 618);
            this.fpSpread.TabIndex = 0;
            // 
            // fpSpread_Sheet1
            // 
            this.fpSpread_Sheet1.Reset();
            this.fpSpread_Sheet1.SheetName = "Sheet1";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // groupBox1
            // 
            this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.groupBox1.Controls.Add(this.checkBoxDragFillDataOnly);
            this.groupBox1.Controls.Add(this.checkBoxEnableDragFillMenu);
            this.groupBox1.Controls.Add(this.checkBoxAllowDragFill);
            this.groupBox1.Location = new System.Drawing.Point(3, 16);
            this.groupBox1.Margin = new System.Windows.Forms.Padding(2);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(2);
            this.groupBox1.Size = new System.Drawing.Size(151, 119);
            this.groupBox1.TabIndex = 18;
            this.groupBox1.TabStop = false;
            this.groupBox1.Text = "Drag Fill";
            // 
            // checkBoxDragFillDataOnly
            // 
            this.checkBoxDragFillDataOnly.AutoSize = true;
            this.checkBoxDragFillDataOnly.Location = new System.Drawing.Point(14, 88);
            this.checkBoxDragFillDataOnly.Name = "checkBoxDragFillDataOnly";
            this.checkBoxDragFillDataOnly.Size = new System.Drawing.Size(105, 17);
            this.checkBoxDragFillDataOnly.TabIndex = 12;
            this.checkBoxDragFillDataOnly.Text = "DragFillDataOnly";
            this.checkBoxDragFillDataOnly.UseVisualStyleBackColor = true;
            // 
            // checkBoxEnableDragFillMenu
            // 
            this.checkBoxEnableDragFillMenu.AutoSize = true;
            this.checkBoxEnableDragFillMenu.Checked = true;
            this.checkBoxEnableDragFillMenu.CheckState = System.Windows.Forms.CheckState.Checked;
            this.checkBoxEnableDragFillMenu.Location = new System.Drawing.Point(14, 56);
            this.checkBoxEnableDragFillMenu.Name = "checkBoxEnableDragFillMenu";
            this.checkBoxEnableDragFillMenu.Size = new System.Drawing.Size(121, 17);
            this.checkBoxEnableDragFillMenu.TabIndex = 11;
            this.checkBoxEnableDragFillMenu.Text = "EnableDragFillMenu";
            this.checkBoxEnableDragFillMenu.UseVisualStyleBackColor = true;
            // 
            // checkBoxAllowDragFill
            // 
            this.checkBoxAllowDragFill.AutoSize = true;
            this.checkBoxAllowDragFill.Checked = true;
            this.checkBoxAllowDragFill.CheckState = System.Windows.Forms.CheckState.Checked;
            this.checkBoxAllowDragFill.Location = new System.Drawing.Point(14, 23);
            this.checkBoxAllowDragFill.Margin = new System.Windows.Forms.Padding(2);
            this.checkBoxAllowDragFill.Name = "checkBoxAllowDragFill";
            this.checkBoxAllowDragFill.Size = new System.Drawing.Size(92, 17);
            this.checkBoxAllowDragFill.TabIndex = 10;
            this.checkBoxAllowDragFill.Text = "Allow Drag Fill";
            // 
            // groupBox2
            // 
            this.groupBox2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.groupBox2.Controls.Add(this.comboDragFillMode);
            this.groupBox2.Location = new System.Drawing.Point(2, 139);
            this.groupBox2.Margin = new System.Windows.Forms.Padding(2);
            this.groupBox2.Name = "groupBox2";
            this.groupBox2.Padding = new System.Windows.Forms.Padding(2);
            this.groupBox2.Size = new System.Drawing.Size(152, 59);
            this.groupBox2.TabIndex = 19;
            this.groupBox2.TabStop = false;
            this.groupBox2.Text = "Drag Fill Mode";
            // 
            // comboDragFillMode
            // 
            this.comboDragFillMode.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.comboDragFillMode.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.comboDragFillMode.FormattingEnabled = true;
            this.comboDragFillMode.Location = new System.Drawing.Point(14, 22);
            this.comboDragFillMode.Name = "comboDragFillMode";
            this.comboDragFillMode.Size = new System.Drawing.Size(121, 21);
            this.comboDragFillMode.TabIndex = 0;
            // 
            // groupBox3
            // 
            this.groupBox3.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.groupBox3.Controls.Add(this.comboSampleData);
            this.groupBox3.Location = new System.Drawing.Point(5, 203);
            this.groupBox3.Name = "groupBox3";
            this.groupBox3.Size = new System.Drawing.Size(149, 70);
            this.groupBox3.TabIndex = 1;
            this.groupBox3.TabStop = false;
            this.groupBox3.Text = "Sample Data";
            // 
            // comboSampleData
            // 
            this.comboSampleData.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.comboSampleData.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.comboSampleData.FormattingEnabled = true;
            this.comboSampleData.Items.AddRange(new object[] {
            "Number",
            "Number (Text)",
            "String",
            "DateTime",
            "Combine"});
            this.comboSampleData.Location = new System.Drawing.Point(12, 30);
            this.comboSampleData.Name = "comboSampleData";
            this.comboSampleData.Size = new System.Drawing.Size(121, 21);
            this.comboSampleData.TabIndex = 0;
            // 
            // groupBox4
            // 
            this.groupBox4.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.groupBox4.Controls.Add(this.txtFillCount);
            this.groupBox4.Controls.Add(this.btnFill);
            this.groupBox4.Controls.Add(this.checkBoxFillSeries);
            this.groupBox4.Controls.Add(this.checkBoxOnlyValues);
            this.groupBox4.Controls.Add(this.checkBoxOnlyData);
            this.groupBox4.Controls.Add(this.comboFillDirection);
            this.groupBox4.Controls.Add(this.label6);
            this.groupBox4.Controls.Add(this.label2);
            this.groupBox4.Enabled = false;
            this.groupBox4.Location = new System.Drawing.Point(0, 294);
            this.groupBox4.Name = "groupBox4";
            this.groupBox4.Size = new System.Drawing.Size(157, 243);
            this.groupBox4.TabIndex = 21;
            this.groupBox4.TabStop = false;
            this.groupBox4.Text = "Custom Fill";
            // 
            // txtFillCount
            // 
            this.txtFillCount.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.txtFillCount.Location = new System.Drawing.Point(8, 43);
            this.txtFillCount.Name = "txtFillCount";
            this.txtFillCount.Size = new System.Drawing.Size(143, 20);
            this.txtFillCount.TabIndex = 20;
            // 
            // checkBoxFillSeries
            // 
            this.checkBoxFillSeries.AutoSize = true;
            this.checkBoxFillSeries.Location = new System.Drawing.Point(8, 166);
            this.checkBoxFillSeries.Name = "checkBoxFillSeries";
            this.checkBoxFillSeries.Size = new System.Drawing.Size(70, 17);
            this.checkBoxFillSeries.TabIndex = 19;
            this.checkBoxFillSeries.Text = "Fill Series";
            this.checkBoxFillSeries.UseVisualStyleBackColor = true;
            // 
            // checkBoxOnlyValues
            // 
            this.checkBoxOnlyValues.AutoSize = true;
            this.checkBoxOnlyValues.Location = new System.Drawing.Point(8, 143);
            this.checkBoxOnlyValues.Name = "checkBoxOnlyValues";
            this.checkBoxOnlyValues.Size = new System.Drawing.Size(82, 17);
            this.checkBoxOnlyValues.TabIndex = 18;
            this.checkBoxOnlyValues.Text = "Only Values";
            this.checkBoxOnlyValues.UseVisualStyleBackColor = true;
            // 
            // checkBoxOnlyData
            // 
            this.checkBoxOnlyData.AutoSize = true;
            this.checkBoxOnlyData.Location = new System.Drawing.Point(8, 120);
            this.checkBoxOnlyData.Name = "checkBoxOnlyData";
            this.checkBoxOnlyData.Size = new System.Drawing.Size(73, 17);
            this.checkBoxOnlyData.TabIndex = 17;
            this.checkBoxOnlyData.Text = "Only Data";
            this.checkBoxOnlyData.UseVisualStyleBackColor = true;
            // 
            // comboFillDirection
            // 
            this.comboFillDirection.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.comboFillDirection.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.comboFillDirection.FormattingEnabled = true;
            this.comboFillDirection.Location = new System.Drawing.Point(8, 87);
            this.comboFillDirection.Name = "comboFillDirection";
            this.comboFillDirection.Size = new System.Drawing.Size(143, 21);
            this.comboFillDirection.TabIndex = 16;
            // 
            // label6
            // 
            this.label6.AutoSize = true;
            this.label6.Location = new System.Drawing.Point(5, 71);
            this.label6.Name = "label6";
            this.label6.Size = new System.Drawing.Size(67, 13);
            this.label6.TabIndex = 15;
            this.label6.Text = "Fill Direction:";
            // 
            // label2
            // 
            this.label2.AutoSize = true;
            this.label2.Location = new System.Drawing.Point(5, 27);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(53, 13);
            this.label2.TabIndex = 14;
            this.label2.Text = "Fill Count:";
            // 
            // btnFill
            // 
            this.btnFill.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
            | System.Windows.Forms.AnchorStyles.Right)));
            this.btnFill.Location = new System.Drawing.Point(18, 198);
            this.btnFill.Name = "btnFill";
            this.btnFill.Size = new System.Drawing.Size(120, 23);
            this.btnFill.TabIndex = 20;
            this.btnFill.Text = "Fill";
            this.btnFill.UseVisualStyleBackColor = true;
            // 
            // DragFillDemo
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "DragFillDemo";
            this.Size = new System.Drawing.Size(635, 618);
            this.pnlMain.ResumeLayout(false);
            this.pnlControls.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread_Sheet1)).EndInit();
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            this.groupBox2.ResumeLayout(false);
            this.groupBox3.ResumeLayout(false);
            this.groupBox4.ResumeLayout(false);
            this.groupBox4.PerformLayout();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread fpSpread;
        private FarPoint.Win.Spread.SheetView fpSpread_Sheet1;
        internal System.Windows.Forms.GroupBox groupBox2;
        private System.Windows.Forms.ComboBox comboDragFillMode;
        internal System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.CheckBox checkBoxDragFillDataOnly;
        private System.Windows.Forms.CheckBox checkBoxEnableDragFillMenu;
        internal System.Windows.Forms.CheckBox checkBoxAllowDragFill;
        private System.Windows.Forms.GroupBox groupBox3;
        private System.Windows.Forms.ComboBox comboSampleData;
        private System.Windows.Forms.GroupBox groupBox4;
        private System.Windows.Forms.TextBox txtFillCount;
        private System.Windows.Forms.CheckBox checkBoxFillSeries;
        private System.Windows.Forms.CheckBox checkBoxOnlyValues;
        private System.Windows.Forms.CheckBox checkBoxOnlyData;
        private System.Windows.Forms.ComboBox comboFillDirection;
        private System.Windows.Forms.Label label6;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.Button btnFill;
    }
}
